| SyStatChange |
| Logical Entity Name | SyStatChange |
| Default Table Name | SyStatChange |
| Physical Only | NO |
| Definition | |
| Note |
| SyStatChange Columns |
| ColumnName | Domain | Datatype | NULL | Definition |
| SyStudentID | int | NO | ||
| AdEnrollID | int | NO | ||
| Comment | varchar(255) | NO | ||
| EffectiveDate | datetime | NO | ||
| NewSyStatusID | int | NO | ||
| PrevSyStatusID | int | NO | ||
| NewSySchoolStatusID | int | NO | ||
| PrevSySchoolStatusID | int | NO | ||
| NewAdAttStatID | int | YES | ||
| PrevAdAttStatID | int | YES | ||
| InternalComm | text | NO | ||
| BeginDate | datetime | YES | ||
| ReturnDate | datetime | YES | ||
| Status | char(1) | YES | ||
| ModFlag | char(1) | YES | ||
| CmEventID | int | NO | ||
| UserID | int | NO | ||
| DateAdded | datetime | NO | ||
| DateLstMod | datetime | NO | ||
| ts | timestamp | NO | ||
SyStatChangeID |
int | NO | ||
| AdReasonID | int | YES | ||
| Type | char(1) | YES | ||
| PrevValue | varchar(30) | YES | ||
| NewValue | varchar(30) | YES | ||
AdTermID |
int | YES | ||
| StoredLDA | datetime | YES | ||
| NSLDSWithdrawalDate | datetime | YES |
| SyStatChange Primary and Unique Keys |
| Key Name | Key Type | Keys |
| SyStatChange_SyStatChangeID_U_C_IDX | PrimaryKey | SyStatChangeID |
| SyStatChange Foreign Keys |
| Parent Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype | Not For Replication |
| AdTerm | Non-Identifying | Zero or One to Zero or More | FK_SyStatChange_AdTermID_AdTerm_AdTermID | AdTermID | NO | YES |
| Child Relationships: |
| Table Name | Type | Cardinality | Constraint Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype | Not For Replication |
| PlStatChange | Non-Identifying | One To Zero or More | FK_PlStatChange_PlStatChangeID_SyStatChange_SyStatChangeID | NO | YES | |||
| SaEnrollAcctStatus | Non-Identifying | One To Zero or More | FK_SaEnrollAcctStatus_SyStatChangeID_SyStatChange_SyStatChangeID | NO | YES | |||
| SyAudit_SaEnrollAcctStatus | Non-Identifying | One To Zero or More | FK_SyAudit_SaEnrollAcctStatus_SyStatChangeID_SyStatChange_SyStatChangeID | NO | YES |
| SyStatChange Check Constraints |
| Check Constraint Name | CheckConstraint |